Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	105000
Missing cells	8563
Missing cells (%)	0.5%
Duplicate rows	790
Duplicate rows (%)	0.8%
Total size in memory	14.4 MiB
Average record size in memory	144.0 B

Variable types

Numeric	16
Categorical	2

Alerts

`rerun` has constant value "301.0"	Constant
Dataset has 790 (0.8%) duplicate rows	Duplicates
`objid` is highly correlated with `run`	High correlation
`u` is highly correlated with `g` and 3 other fields	High correlation
`g` is highly correlated with `u` and 3 other fields	High correlation
`r` is highly correlated with `u` and 3 other fields	High correlation
`i` is highly correlated with `u` and 3 other fields	High correlation
`z` is highly correlated with `u` and 3 other fields	High correlation
`run` is highly correlated with `objid`	High correlation
`specobjid` is highly correlated with `plate` and 1 other fields	High correlation
`plate` is highly correlated with `specobjid` and 1 other fields	High correlation
`mjd` is highly correlated with `specobjid` and 1 other fields	High correlation
`objid` is highly correlated with `run`	High correlation
`u` is highly correlated with `g` and 3 other fields	High correlation
`g` is highly correlated with `u` and 3 other fields	High correlation
`r` is highly correlated with `u` and 3 other fields	High correlation
`i` is highly correlated with `u` and 3 other fields	High correlation
`z` is highly correlated with `u` and 3 other fields	High correlation
`run` is highly correlated with `objid`	High correlation
`specobjid` is highly correlated with `plate` and 1 other fields	High correlation
`plate` is highly correlated with `specobjid` and 1 other fields	High correlation
`mjd` is highly correlated with `specobjid` and 1 other fields	High correlation
`objid` is highly correlated with `run`	High correlation
`u` is highly correlated with `g`	High correlation
`g` is highly correlated with `u` and 3 other fields	High correlation
`r` is highly correlated with `g` and 2 other fields	High correlation
`i` is highly correlated with `g` and 2 other fields	High correlation
`z` is highly correlated with `g` and 2 other fields	High correlation
`run` is highly correlated with `objid`	High correlation
`specobjid` is highly correlated with `plate` and 1 other fields	High correlation
`plate` is highly correlated with `specobjid` and 1 other fields	High correlation
`mjd` is highly correlated with `specobjid` and 1 other fields	High correlation
`rerun` is highly correlated with `class`	High correlation
`class` is highly correlated with `rerun`	High correlation
`objid` is highly correlated with `ra` and 5 other fields	High correlation
`ra` is highly correlated with `objid` and 3 other fields	High correlation
`dec` is highly correlated with `objid` and 5 other fields	High correlation
`u` is highly correlated with `g` and 3 other fields	High correlation
`g` is highly correlated with `u` and 5 other fields	High correlation
`r` is highly correlated with `u` and 5 other fields	High correlation
`i` is highly correlated with `u` and 4 other fields	High correlation
`z` is highly correlated with `u` and 4 other fields	High correlation
`run` is highly correlated with `objid` and 5 other fields	High correlation
`field` is highly correlated with `ra`	High correlation
`specobjid` is highly correlated with `objid` and 5 other fields	High correlation
`class` is highly correlated with `g` and 7 other fields	High correlation
`redshift` is highly correlated with `g` and 2 other fields	High correlation
`plate` is highly correlated with `objid` and 5 other fields	High correlation
`mjd` is highly correlated with `objid` and 5 other fields	High correlation

Reproduction

Analysis started	2022-06-27 16:02:32.799465
Analysis finished	2022-06-27 16:17:30.366459
Duration	14 minutes and 57.57 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

objid
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	67951
Distinct (%)	65.0%
Missing	471
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.2376626 × 10¹⁸

Minimum	1.237645942 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	1.237645942 × 10¹⁸
5-th percentile	1.237650763 × 10¹⁸
Q1	1.237657613 × 10¹⁸
median	1.237662237 × 10¹⁸
Q3	1.237667211 × 10¹⁸
95-th percentile	1.2376786 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Range	3.458899502 × 10¹³
Interquartile range (IQR)	9.59764208 × 10¹²

Descriptive statistics

Standard deviation	7.297186796 × 10¹²
Coefficient of variation (CV)	5.895941911 × 10^-6
Kurtosis	-0.100111674
Mean	1.2376626 × 10¹⁸
Median Absolute Deviation (MAD)	4.62837783 × 10¹²
Skewness	0.2892833877
Sum	1.293716339 × 10²³
Variance	5.324893513 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.237657611 × 10¹⁸	22	< 0.1%
1.237665549 × 10¹⁸	18	< 0.1%
1.237659326 × 10¹⁸	18	< 0.1%
1.237666338 × 10¹⁸	17	< 0.1%
1.237661384 × 10¹⁸	17	< 0.1%
1.237656906 × 10¹⁸	17	< 0.1%
1.237659326 × 10¹⁸	16	< 0.1%
1.237666338 × 10¹⁸	16	< 0.1%
1.237648703 × 10¹⁸	15	< 0.1%
1.237655743 × 10¹⁸	13	< 0.1%
Other values (67941)	104360	99.4%
(Missing)	471	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.237645942 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	2	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	2	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	3	< 0.1%

Value	Count	Frequency (%)
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	2	< 0.1%
1.237680531 × 10¹⁸	2	< 0.1%
1.237680531 × 10¹⁸	2	< 0.1%
1.237680531 × 10¹⁸	4	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%

ra
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	99998
Distinct (%)	95.7%
Missing	503
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	177.3636281

Minimum	0.0130606182
Maximum	359.9996152
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	0.0130606182
5-th percentile	19.29229108
Q1	136.2073294
median	180.3154659
Q3	224.3855998
95-th percentile	331.8527005
Maximum	359.9996152
Range	359.9865546
Interquartile range (IQR)	88.17827047

Descriptive statistics

Standard deviation	78.32375233
Coefficient of variation (CV)	0.4415998542
Kurtosis	0.2894332768
Mean	177.3636281
Median Absolute Deviation (MAD)	44.08668798
Skewness	-0.1478046655
Sum	18533967.05
Variance	6134.610179
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
135.7313013	6	< 0.1%
0.3848705536	5	< 0.1%
310.5235637	5	< 0.1%
181.2881219	5	< 0.1%
240.2767225	5	< 0.1%
169.6261759	5	< 0.1%
132.7264225	5	< 0.1%
3.491397341	5	< 0.1%
355.7171984	4	< 0.1%
329.954208	4	< 0.1%
Other values (99988)	104448	99.5%
(Missing)	503	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0130606182	1	< 0.1%
0.013890033	1	< 0.1%
0.0151766885	1	< 0.1%
0.01639243	1	< 0.1%
0.0193603276	1	< 0.1%
0.029838174	1	< 0.1%
0.0302214478	1	< 0.1%
0.0314677494	1	< 0.1%
0.03805438	1	< 0.1%
0.0392718417	1	< 0.1%

Value	Count	Frequency (%)
359.9996152	1	< 0.1%
359.9818523	1	< 0.1%
359.9739335	1	< 0.1%
359.9730615	1	< 0.1%
359.972675	3	< 0.1%
359.9644062	1	< 0.1%
359.961213	1	< 0.1%
359.9537366	1	< 0.1%
359.9489687	1	< 0.1%
359.9481466	1	< 0.1%

dec
Real number (ℝ)

HIGH CORRELATION

Distinct	99998
Distinct (%)	95.7%
Missing	514
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	25.07701865

Minimum	-19.49545595
Maximum	84.49049355
Zeros	0
Zeros (%)	0.0%
Negative	12314
Negative (%)	11.7%
Memory size	820.4 KiB

Quantile statistics

Minimum	-19.49545595
5-th percentile	-2.564156087
Q1	6.796899074
median	23.97616554
Q3	40.35628529
95-th percentile	59.54625483
Maximum	84.49049355
Range	103.9859495
Interquartile range (IQR)	33.55938621

Descriptive statistics

Standard deviation	20.54955798
Coefficient of variation (CV)	0.8194577777
Kurtosis	-0.9006547811
Mean	25.07701865
Median Absolute Deviation (MAD)	16.77616393
Skewness	0.2645675607
Sum	2620197.371
Variance	422.284333
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.42204467	6	< 0.1%
40.43167904	5	< 0.1%
7.134754626	5	< 0.1%
4.676497556	5	< 0.1%
21.22672474	5	< 0.1%
27.29241845	5	< 0.1%
17.46669494	5	< 0.1%
32.90371006	4	< 0.1%
44.8582933	4	< 0.1%
3.881093899	4	< 0.1%
Other values (99988)	104438	99.5%
(Missing)	514	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-19.49545595	1	< 0.1%
-19.36457646	1	< 0.1%
-19.29477092	1	< 0.1%
-19.25250863	1	< 0.1%
-19.05256932	1	< 0.1%
-19.04569538	1	< 0.1%
-19.00869862	1	< 0.1%
-18.9640579	1	< 0.1%
-18.9048726	1	< 0.1%
-18.86596069	1	< 0.1%

Value	Count	Frequency (%)
84.49049355	1	< 0.1%
84.41565961	1	< 0.1%
84.39379134	1	< 0.1%
84.37506776	1	< 0.1%
84.35513366	1	< 0.1%
84.34370967	1	< 0.1%
84.33491061	1	< 0.1%
84.33347541	1	< 0.1%
84.31706748	1	< 0.1%
84.31706407	1	< 0.1%

u
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	79840
Distinct (%)	76.4%
Missing	453
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	18.64612461

Minimum	10.61181
Maximum	19.59995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	10.61181
5-th percentile	16.994123
Q1	18.226545
median	18.88153
Q3	19.2784
95-th percentile	19.536647
Maximum	19.59995
Range	8.98814
Interquartile range (IQR)	1.051855

Descriptive statistics

Standard deviation	0.8286945168
Coefficient of variation (CV)	0.04444325748
Kurtosis	2.614982487
Mean	18.64612461
Median Absolute Deviation (MAD)	0.46885
Skewness	-1.410525129
Sum	1949396.389
Variance	0.6867346022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.28232	8	< 0.1%
19.50051	7	< 0.1%
18.5609	7	< 0.1%
19.5632	7	< 0.1%
19.06528	7	< 0.1%
18.935	7	< 0.1%
18.97973	7	< 0.1%
19.29348	7	< 0.1%
19.17588	7	< 0.1%
19.46334	7	< 0.1%
Other values (79830)	104476	99.5%
(Missing)	453	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.61181	1	< 0.1%
10.99623	1	< 0.1%
11.49125	1	< 0.1%
11.50794	1	< 0.1%
11.71639	1	< 0.1%
11.84577	1	< 0.1%
11.96091	1	< 0.1%
12.05521	1	< 0.1%
12.10168	1	< 0.1%
12.10933	1	< 0.1%

Value	Count	Frequency (%)
19.59995	1	< 0.1%
19.59994	1	< 0.1%
19.59993	1	< 0.1%
19.59992	3	< 0.1%
19.5999	1	< 0.1%
19.59989	2	< 0.1%
19.59987	2	< 0.1%
19.59983	1	< 0.1%
19.59982	1	< 0.1%
19.59981	2	< 0.1%

g
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	85895
Distinct (%)	82.2%
Missing	498
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	17.44646107

Minimum	9.668339
Maximum	19.99605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	9.668339
5-th percentile	15.6636305
Q1	16.876755
median	17.543095
Q3	18.09984
95-th percentile	19.0453195
Maximum	19.99605
Range	10.327711
Interquartile range (IQR)	1.223085

Descriptive statistics

Standard deviation	1.003252479
Coefficient of variation (CV)	0.05750464093
Kurtosis	1.647466801
Mean	17.44646107
Median Absolute Deviation (MAD)	0.599615
Skewness	-0.7048097714
Sum	1823190.075
Variance	1.006515537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.00261	7	< 0.1%
19.36184	6	< 0.1%
17.70518	6	< 0.1%
17.62819	6	< 0.1%
18.33341	6	< 0.1%
18.61752	6	< 0.1%
18.06462	6	< 0.1%
18.78448	6	< 0.1%
17.82619	5	< 0.1%
19.15025	5	< 0.1%
Other values (85885)	104443	99.5%
(Missing)	498	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.668339	1	< 0.1%
9.988	1	< 0.1%
9.989008	1	< 0.1%
10.0348	1	< 0.1%
10.0985	1	< 0.1%
10.39004	1	< 0.1%
10.4982	1	< 0.1%
10.51139	1	< 0.1%
10.5311	1	< 0.1%
10.53353	1	< 0.1%

Value	Count	Frequency (%)
19.99605	1	< 0.1%
19.9842	1	< 0.1%
19.97499	1	< 0.1%
19.9073	1	< 0.1%
19.90642	1	< 0.1%
19.89474	1	< 0.1%
19.87725	1	< 0.1%
19.86832	1	< 0.1%
19.86373	1	< 0.1%
19.86168	1	< 0.1%

r
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	87969
Distinct (%)	84.2%
Missing	536
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	16.93342247

Minimum	9.005167
Maximum	31.9901
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	9.005167
5-th percentile	15.060213
Q1	16.220455
median	16.93446
Q3	17.648455
95-th percentile	18.928511
Maximum	31.9901
Range	22.984933
Interquartile range (IQR)	1.428

Descriptive statistics

Standard deviation	1.158454844
Coefficient of variation (CV)	0.0684123275
Kurtosis	2.035794
Mean	16.93342247
Median Absolute Deviation (MAD)	0.714005
Skewness	-0.1402745977
Sum	1768933.045
Variance	1.342017625
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.36591	6	< 0.1%
19.23513	6	< 0.1%
18.18169	6	< 0.1%
18.79991	6	< 0.1%
18.88791	5	< 0.1%
17.18694	5	< 0.1%
17.41842	5	< 0.1%
17.03412	5	< 0.1%
18.33845	5	< 0.1%
18.48827	5	< 0.1%
Other values (87959)	104410	99.4%
(Missing)	536	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.005167	1	< 0.1%
9.050494	1	< 0.1%
9.167526	1	< 0.1%
9.356278	1	< 0.1%
9.533339	1	< 0.1%
9.564629	1	< 0.1%
9.603218	1	< 0.1%
9.685797	1	< 0.1%
9.690582	1	< 0.1%
9.73144	1	< 0.1%

Value	Count	Frequency (%)
31.9901	1	< 0.1%
29.57186	1	< 0.1%
28.9422	1	< 0.1%
28.20384	1	< 0.1%
27.06385	1	< 0.1%
26.79265	1	< 0.1%
26.59133	1	< 0.1%
26.30579	1	< 0.1%
25.49612	1	< 0.1%
24.9727	1	< 0.1%

i
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	88623
Distinct (%)	84.8%
Missing	506
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	16.68246364

Minimum	8.848403
Maximum	32.14147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	8.848403
5-th percentile	14.751799
Q1	15.889685
median	16.64607
Q3	17.41619
95-th percentile	18.8476525
Maximum	32.14147
Range	23.293067
Interquartile range (IQR)	1.526505

Descriptive statistics

Standard deviation	1.23673037
Coefficient of variation (CV)	0.07413355708
Kurtosis	1.777398393
Mean	16.68246364
Median Absolute Deviation (MAD)	0.76327
Skewness	0.03995694952
Sum	1743217.355
Variance	1.529502008
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.24153	6	< 0.1%
19.02179	6	< 0.1%
17.37613	6	< 0.1%
18.77454	6	< 0.1%
18.13322	6	< 0.1%
18.57672	5	< 0.1%
15.99426	5	< 0.1%
18.1792	5	< 0.1%
18.7631	5	< 0.1%
18.99187	5	< 0.1%
Other values (88613)	104439	99.5%
(Missing)	506	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.848403	1	< 0.1%
8.896696	1	< 0.1%
8.917489	1	< 0.1%
9.082433	1	< 0.1%
9.10011	1	< 0.1%
9.321235	1	< 0.1%
9.400904	1	< 0.1%
9.406895	1	< 0.1%
9.456314	1	< 0.1%
9.46208	1	< 0.1%

Value	Count	Frequency (%)
32.14147	1	< 0.1%
32.10178	1	< 0.1%
30.16359	1	< 0.1%
27.47143	1	< 0.1%
26.9687	1	< 0.1%
26.89399	1	< 0.1%
26.49636	1	< 0.1%
26.0441	1	< 0.1%
25.15362	1	< 0.1%
24.87711	1	< 0.1%

z
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	89451
Distinct (%)	85.6%
Missing	518
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	16.52722576

Minimum	8.947795
Maximum	29.38374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	8.947795
5-th percentile	14.505378
Q1	15.6484
median	16.479285
Q3	17.3203725
95-th percentile	18.82262
Maximum	29.38374
Range	20.435945
Interquartile range (IQR)	1.6719725

Descriptive statistics

Standard deviation	1.308750962
Coefficient of variation (CV)	0.07918757695
Kurtosis	0.8258176243
Mean	16.52722576
Median Absolute Deviation (MAD)	0.835415
Skewness	0.1071717878
Sum	1726797.602
Variance	1.71282908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.26416	6	< 0.1%
18.61593	6	< 0.1%
19.05516	5	< 0.1%
16.36791	5	< 0.1%
19.0807	5	< 0.1%
19.08307	5	< 0.1%
18.38336	5	< 0.1%
15.65332	5	< 0.1%
18.6076	5	< 0.1%
15.51277	5	< 0.1%
Other values (89441)	104430	99.5%
(Missing)	518	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.947795	1	< 0.1%
9.114825	1	< 0.1%
9.228836	1	< 0.1%
9.537069	1	< 0.1%
9.612333	1	< 0.1%
9.741912	1	< 0.1%
9.778091	1	< 0.1%
9.836641	1	< 0.1%
9.893856	1	< 0.1%
9.918173	1	< 0.1%

Value	Count	Frequency (%)
29.38374	1	< 0.1%
28.79055	1	< 0.1%
28.02649	1	< 0.1%
27.67336	1	< 0.1%
26.51354	1	< 0.1%
26.04661	1	< 0.1%
25.33364	1	< 0.1%
24.70431	1	< 0.1%
24.68215	1	< 0.1%
24.56498	1	< 0.1%

run
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	516
Distinct (%)	0.5%
Missing	508
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	3987.288836

Minimum	109
Maximum	8162
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	109
5-th percentile	1231
Q1	2826
median	3903
Q3	5061
95-th percentile	7713
Maximum	8162
Range	8053
Interquartile range (IQR)	2235

Descriptive statistics

Standard deviation	1698.666908
Coefficient of variation (CV)	0.4260205313
Kurtosis	-0.09943297995
Mean	3987.288836
Median Absolute Deviation (MAD)	1078
Skewness	0.2897279982
Sum	416639785
Variance	2885469.265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2243	3116	3.0%
3893	2422	2.3%
3704	2221	2.1%
2986	2166	2.1%
752	2112	2.0%
5972	2103	2.0%
4674	1850	1.8%
4576	1618	1.5%
4294	1575	1.5%
3705	1536	1.5%
Other values (506)	83773	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
109	16	< 0.1%
211	43	< 0.1%
259	3	< 0.1%
287	2	< 0.1%
307	86	0.1%
308	48	< 0.1%
745	113	0.1%
752	2112	2.0%
756	874	0.8%
994	15	< 0.1%

Value	Count	Frequency (%)
8162	28	< 0.1%
8158	2	< 0.1%
8157	11	< 0.1%
8156	32	< 0.1%
8155	13	< 0.1%
8151	14	< 0.1%
8150	5	< 0.1%
8149	2	< 0.1%
8142	1	< 0.1%
8116	70	0.1%

rerun
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	539
Missing (%)	0.5%
Memory size	820.4 KiB

301.0	104461

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	522305
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	301.0
2nd row	301.0
3rd row	301.0
4th row	301.0
5th row	301.0

Common Values

Value	Count	Frequency (%)
301.0	104461	99.5%
(Missing)	539	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
301.0	104461	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	208922	40.0%
3	104461	20.0%
1	104461	20.0%
.	104461	20.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	417844	80.0%
Other Punctuation	104461	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	208922	50.0%
3	104461	25.0%
1	104461	25.0%

Other Punctuation

Value	Count	Frequency (%)
.	104461	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	522305	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	208922	40.0%
3	104461	20.0%
1	104461	20.0%
.	104461	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	522305	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	208922	40.0%
3	104461	20.0%
1	104461	20.0%
.	104461	20.0%

camcol
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	496
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.274353135

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.620960607
Coefficient of variation (CV)	0.4950475835
Kurtosis	-1.141387787
Mean	3.274353135
Median Absolute Deviation (MAD)	1
Skewness	0.1268195353
Sum	342183
Variance	2.627513289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	19393	18.5%
3	19318	18.4%
1	19149	18.2%
2	19037	18.1%
5	16208	15.4%
6	11399	10.9%
(Missing)	496	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19149	18.2%
2	19037	18.1%
3	19318	18.4%
4	19393	18.5%
5	16208	15.4%
6	11399	10.9%

Value	Count	Frequency (%)
6	11399	10.9%
5	16208	15.4%
4	19393	18.5%
3	19318	18.4%
2	19037	18.1%
1	19149	18.2%

field
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	840
Distinct (%)	0.8%
Missing	476
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	187.085808

Minimum	11
Maximum	982
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	11
5-th percentile	31
Q1	85
median	153
Q3	249
95-th percentile	476
Maximum	982
Range	971
Interquartile range (IQR)	164

Descriptive statistics

Standard deviation	140.884349
Coefficient of variation (CV)	0.7530466927
Kurtosis	2.616465326
Mean	187.085808
Median Absolute Deviation (MAD)	77
Skewness	1.494813155
Sum	19554957
Variance	19848.39979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98	463	0.4%
61	462	0.4%
99	455	0.4%
65	450	0.4%
67	448	0.4%
63	445	0.4%
97	444	0.4%
66	439	0.4%
56	438	0.4%
131	432	0.4%
Other values (830)	100048	95.3%
(Missing)	476	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	215	0.2%
12	188	0.2%
13	227	0.2%
14	211	0.2%
15	192	0.2%
16	209	0.2%
17	222	0.2%
18	241	0.2%
19	221	0.2%
20	248	0.2%

Value	Count	Frequency (%)
982	1	< 0.1%
977	1	< 0.1%
974	1	< 0.1%
972	1	< 0.1%
971	1	< 0.1%
970	1	< 0.1%
860	1	< 0.1%
848	1	< 0.1%
846	1	< 0.1%
845	2	< 0.1%

specobjid
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	100000
Distinct (%)	95.7%
Missing	498
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.968231684 × 10¹⁸

Minimum	2.994896774 × 10¹⁷
Maximum	1.317645238 × 10¹⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	2.994896774 × 10¹⁷
5-th percentile	4.469861826 × 10¹⁷
Q1	1.339866632 × 10¹⁸
median	2.367807557 × 10¹⁸
Q3	3.30910642 × 10¹⁸
95-th percentile	8.715861478 × 10¹⁸
Maximum	1.317645238 × 10¹⁹
Range	1.287696271 × 10¹⁹
Interquartile range (IQR)	1.969239787 × 10¹⁸

Descriptive statistics

Standard deviation	2.552331925 × 10¹⁸
Coefficient of variation (CV)	0.8598829863
Kurtosis	2.949536078
Mean	2.968231684 × 10¹⁸
Median Absolute Deviation (MAD)	9.796265337 × 10¹⁷
Skewness	1.793483855
Sum	3.101861474 × 10²³
Variance	6.514398253 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.446692163 × 10¹⁸	6	< 0.1%
7.202432938 × 10¹⁸	6	< 0.1%
1.34212606 × 10¹⁸	6	< 0.1%
1.621351993 × 10¹⁸	5	< 0.1%
2.921850791 × 10¹⁸	5	< 0.1%
1.104539735 × 10¹⁸	5	< 0.1%
8.551262136 × 10¹⁸	5	< 0.1%
1.375940167 × 10¹⁸	4	< 0.1%
4.255045766 × 10¹⁸	4	< 0.1%
8.549063663 × 10¹⁸	4	< 0.1%
Other values (99990)	104452	99.5%
(Missing)	498	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.994896774 × 10¹⁷	1	< 0.1%
2.995190894 × 10¹⁷	1	< 0.1%
2.995278855 × 10¹⁷	1	< 0.1%
2.995669181 × 10¹⁷	2	< 0.1%
2.995935813 × 10¹⁷	1	< 0.1%
2.996007281 × 10¹⁷	1	< 0.1%
2.996048513 × 10¹⁷	1	< 0.1%
2.996169459 × 10¹⁷	1	< 0.1%
2.996177705 × 10¹⁷	1	< 0.1%
2.996375618 × 10¹⁷	1	< 0.1%

Value	Count	Frequency (%)
1.317645238 × 10¹⁹	2	< 0.1%
1.314852314 × 10¹⁹	1	< 0.1%
1.314739421 × 10¹⁹	1	< 0.1%
1.314731203 × 10¹⁹	1	< 0.1%
1.314720015 × 10¹⁹	1	< 0.1%
1.314717266 × 10¹⁹	1	< 0.1%
1.314625265 × 10¹⁹	1	< 0.1%
1.314619217 × 10¹⁹	1	< 0.1%
1.314616001 × 10¹⁹	1	< 0.1%
1.314614324 × 10¹⁹	1	< 0.1%

class
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	820.4 KiB

GALAXY	51323
STAR	39296
QSO	14381

Length

Max length	6
Median length	4
Mean length	4.840619048
Min length	3

Characters and Unicode

Total characters	508265
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STAR
2nd row	GALAXY
3rd row	GALAXY
4th row	GALAXY
5th row	QSO

Common Values

Value	Count	Frequency (%)
GALAXY	51323	48.9%
STAR	39296	37.4%
QSO	14381	13.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
galaxy	51323	48.9%
star	39296	37.4%
qso	14381	13.7%

Most occurring characters

Value	Count	Frequency (%)
A	141942	27.9%
S	53677	10.6%
G	51323	10.1%
L	51323	10.1%
X	51323	10.1%
Y	51323	10.1%
T	39296	7.7%
R	39296	7.7%
Q	14381	2.8%
O	14381	2.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	508265	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	141942	27.9%
S	53677	10.6%
G	51323	10.1%
L	51323	10.1%
X	51323	10.1%
Y	51323	10.1%
T	39296	7.7%
R	39296	7.7%
Q	14381	2.8%
O	14381	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	508265	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	141942	27.9%
S	53677	10.6%
G	51323	10.1%
L	51323	10.1%
X	51323	10.1%
Y	51323	10.1%
T	39296	7.7%
R	39296	7.7%
Q	14381	2.8%
O	14381	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	508265	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	141942	27.9%
S	53677	10.6%
G	51323	10.1%
L	51323	10.1%
X	51323	10.1%
Y	51323	10.1%
T	39296	7.7%
R	39296	7.7%
Q	14381	2.8%
O	14381	2.8%

redshift
Real number (ℝ)

HIGH CORRELATION

Distinct	99298
Distinct (%)	95.0%
Missing	517
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.2024597147

Minimum	-0.004136078
Maximum	7.011245
Zeros	401
Zeros (%)	0.4%
Negative	25265
Negative (%)	24.1%
Memory size	820.4 KiB

Quantile statistics

Minimum	-0.004136078
5-th percentile	-0.00050897616
Q1	7.4106295 × 10^-6
median	0.0483957
Q3	0.101922
95-th percentile	1.454975
Maximum	7.011245
Range	7.015381078
Interquartile range (IQR)	0.1019145894

Descriptive statistics

Standard deviation	0.4840987539
Coefficient of variation (CV)	2.391086813
Kurtosis	16.35971385
Mean	0.2024597147
Median Absolute Deviation (MAD)	0.04840843535
Skewness	3.552813238
Sum	21153.59837
Variance	0.2343516035
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	401	0.4%
0.004153254	13	< 0.1%
0.0004606231	8	< 0.1%
1.30766	6	< 0.1%
0.5738784	6	< 0.1%
1.036473	6	< 0.1%
0.8240715	5	< 0.1%
0.4389864	5	< 0.1%
0.2354126	5	< 0.1%
0.1548114	5	< 0.1%
Other values (99288)	104023	99.1%
(Missing)	517	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.004136078	3	< 0.1%
-0.004020656	1	< 0.1%
-0.004020589	1	< 0.1%
-0.004019734	1	< 0.1%
-0.003955937	1	< 0.1%
-0.00392177	1	< 0.1%
-0.003808179	1	< 0.1%
-0.003798116	1	< 0.1%
-0.003789981	1	< 0.1%
-0.003730139	1	< 0.1%

Value	Count	Frequency (%)
7.011245	1	< 0.1%
6.991177	2	< 0.1%
6.571713	1	< 0.1%
6.517635	1	< 0.1%
6.404233	1	< 0.1%
6.376496	1	< 0.1%
6.354554	1	< 0.1%
6.269251	1	< 0.1%
6.127684	1	< 0.1%
5.908446	1	< 0.1%

plate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6117
Distinct (%)	5.9%
Missing	510
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	2636.85456

Minimum	266
Maximum	11703
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	266
5-th percentile	397
Q1	1190
median	2103
Q3	2939
95-th percentile	7749
Maximum	11703
Range	11437
Interquartile range (IQR)	1749

Descriptive statistics

Standard deviation	2268.470352
Coefficient of variation (CV)	0.8602940739
Kurtosis	2.95245923
Mean	2636.85456
Median Absolute Deviation (MAD)	870
Skewness	1.794538261
Sum	275524933
Variance	5145957.737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2939	238	0.2%
2337	216	0.2%
2299	204	0.2%
2888	202	0.2%
2394	197	0.2%
1596	173	0.2%
2310	169	0.2%
2384	161	0.2%
1433	161	0.2%
2667	161	0.2%
Other values (6107)	102608	97.7%
(Missing)	510	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
266	17	< 0.1%
267	22	< 0.1%
268	18	< 0.1%
269	13	< 0.1%
270	22	< 0.1%
271	18	< 0.1%
272	11	< 0.1%
273	16	< 0.1%
274	9	< 0.1%
275	5	< 0.1%

Value	Count	Frequency (%)
11703	2	< 0.1%
11678	1	< 0.1%
11677	4	< 0.1%
11676	8	< 0.1%
11654	9	< 0.1%
11653	4	< 0.1%
11651	6	< 0.1%
11650	4	< 0.1%
11649	1	< 0.1%
11636	3	< 0.1%

mjd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2167
Distinct (%)	2.1%
Missing	503
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	53943.28491

Minimum	51608
Maximum	58543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	51608
5-th percentile	51957
Q1	52734
median	53734
Q3	54613
95-th percentile	57357
Maximum	58543
Range	6935
Interquartile range (IQR)	1879

Descriptive statistics

Standard deviation	1575.078088
Coefficient of variation (CV)	0.02919877963
Kurtosis	0.4103413998
Mean	53943.28491
Median Absolute Deviation (MAD)	972
Skewness	0.9230120903
Sum	5636911443
Variance	2480870.984
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52411	431	0.4%
53084	426	0.4%
53770	382	0.4%
53050	360	0.3%
52781	347	0.3%
52378	335	0.3%
52765	329	0.3%
53762	326	0.3%
54169	321	0.3%
52641	319	0.3%
Other values (2157)	100921	96.1%
(Missing)	503	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51608	22	< 0.1%
51609	101	0.1%
51612	17	< 0.1%
51613	59	0.1%
51614	12	< 0.1%
51615	70	0.1%
51630	17	< 0.1%
51633	18	< 0.1%
51637	48	< 0.1%
51658	21	< 0.1%

Value	Count	Frequency (%)
58543	14	< 0.1%
58526	13	< 0.1%
58523	8	< 0.1%
58522	7	< 0.1%
58515	20	< 0.1%
58514	12	< 0.1%
58512	14	< 0.1%
58511	11	< 0.1%
58510	29	< 0.1%
58509	1	< 0.1%

fiberid
Real number (ℝ_≥0)

Distinct	1000
Distinct (%)	1.0%
Missing	517
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	343.3096293

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	820.4 KiB

Quantile statistics

Minimum	1
5-th percentile	33
Q1	161
median	328
Q3	504
95-th percentile	709
Maximum	1000
Range	999
Interquartile range (IQR)	343

Descriptive statistics

Standard deviation	218.4626466
Coefficient of variation (CV)	0.6363429044
Kurtosis	-0.2271837203
Mean	343.3096293
Median Absolute Deviation (MAD)	172
Skewness	0.4810569027
Sum	35870020
Variance	47725.92797
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46	216	0.2%
250	209	0.2%
90	208	0.2%
210	207	0.2%
48	207	0.2%
44	205	0.2%
134	203	0.2%
52	199	0.2%
529	194	0.2%
124	193	0.2%
Other values (990)	102442	97.6%
(Missing)	517	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	150	0.1%
2	174	0.2%
3	151	0.1%
4	182	0.2%
5	160	0.2%
6	179	0.2%
7	174	0.2%
8	183	0.2%
9	188	0.2%
10	190	0.2%

Value	Count	Frequency (%)
1000	30	< 0.1%
999	8	< 0.1%
998	18	< 0.1%
997	20	< 0.1%
996	26	< 0.1%
995	9	< 0.1%
994	29	< 0.1%
993	9	< 0.1%
992	30	< 0.1%
991	12	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	objid	ra	dec	u	g	r	i	z	run	rerun	camcol	field	specobjid	class	redshift	plate	mjd	fiberid
0	1.237658e+18	122.472536	29.477546	18.80104	18.79409	19.17904	19.46893	19.62121	2830.0	301.0	1.0	82.0	5.011614e+18	STAR	0.000113	4451.0	55537.0	848.0
1	1.237661e+18	157.220491	38.044462	19.21634	17.36450	16.39222	15.96160	15.62490	3647.0	301.0	1.0	123.0	1.607801e+18	GALAXY	0.107083	1428.0	52998.0	56.0
2	1.237665e+18	128.426499	22.244187	17.58285	16.66683	16.37511	16.23573	16.03283	4517.0	301.0	2.0	113.0	2.171901e+18	GALAXY	0.024777	1929.0	53349.0	144.0
3	1.237655e+18	148.311910	3.603649	19.49339	18.02611	17.21924	16.73868	16.43414	2125.0	301.0	3.0	197.0	6.429279e+17	GALAXY	0.091564	571.0	52286.0	142.0
4	1.237649e+18	188.615906	0.966501	19.11787	18.80892	18.65386	18.43037	18.44886	752.0	301.0	6.0	301.0	3.266113e+17	QSO	1.528742	290.0	51941.0	365.0
5	1.237651e+18	172.252999	-3.638291	19.11441	18.79149	18.63161	18.70045	18.59555	1231.0	301.0	1.0	20.0	3.670583e+17	QSO	0.864346	326.0	52375.0	54.0
6	1.237671e+18	191.230726	-3.112741	19.41399	18.23463	17.74263	17.58676	17.50622	6005.0	301.0	4.0	143.0	3.289917e+18	STAR	-0.000151	2922.0	54612.0	135.0
7	1.237649e+18	239.601256	0.692352	18.96478	17.75327	17.13841	16.75577	16.49653	745.0	301.0	5.0	540.0	3.863387e+17	GALAXY	0.101707	343.0	51692.0	564.0
8	1.237666e+18	210.129818	21.887381	18.97254	17.95227	17.55222	17.25796	17.23362	4678.0	301.0	1.0	62.0	3.118898e+18	GALAXY	0.066814	2770.0	54510.0	565.0
9	1.237665e+18	215.327913	34.261157	18.54177	17.20249	16.58703	16.15198	15.96899	4512.0	301.0	5.0	112.0	2.071777e+18	GALAXY	0.068231	1840.0	53472.0	442.0

Last rows

	objid	ra	dec	u	g	r	i	z	run	rerun	camcol	field	specobjid	class	redshift	plate	mjd	fiberid
104990	1.237662e+18	224.011895	36.243035	18.44631	16.82548	16.07565	15.67125	15.41776	3893.0	301.0	5.0	379.0	1.558349e+18	GALAXY	0.047248	1384.0	53121.0	378.0
104991	1.237672e+18	259.927162	34.800604	18.32557	16.80251	16.02179	15.62505	15.33217	6161.0	301.0	6.0	102.0	5.622990e+18	GALAXY	0.083648	4994.0	55739.0	894.0
104992	1.237661e+18	139.313650	31.772846	17.45713	16.32932	15.96161	15.76178	15.83675	3704.0	301.0	2.0	52.0	2.680879e+18	STAR	0.000030	2381.0	53762.0	403.0
104993	1.237661e+18	140.914231	36.972574	17.34234	16.23905	16.17270	16.18831	16.22020	3606.0	301.0	6.0	119.0	1.434510e+18	STAR	-0.000061	1274.0	52995.0	413.0
104994	1.237671e+18	72.490907	21.889203	18.68200	17.35598	16.78037	16.53070	16.39374	6003.0	301.0	2.0	201.0	3.038955e+18	STAR	0.000052	2699.0	54414.0	549.0
104995	1.237666e+18	53.104646	0.406206	19.56170	18.10295	17.53076	17.22465	17.07487	4849.0	301.0	4.0	809.0	4.673661e+17	GALAXY	0.022364	415.0	51810.0	428.0
104996	1.237667e+18	139.371132	21.871209	19.20145	17.67397	17.09594	16.88945	16.81790	5071.0	301.0	3.0	169.0	2.594136e+18	STAR	0.000077	2304.0	53762.0	227.0
104997	1.237658e+18	195.616433	50.155119	17.31194	16.21064	15.83690	15.70822	15.67614	2964.0	301.0	5.0	367.0	3.646903e+18	STAR	-0.000121	3239.0	54888.0	410.0
104998	1.237662e+18	185.585052	6.434501	18.73713	17.59770	17.01564	16.67914	16.42806	3841.0	301.0	1.0	138.0	1.830781e+18	GALAXY	0.074901	1626.0	53472.0	248.0
104999	1.237652e+18	153.672995	64.455561	19.11557	18.84617	18.69063	18.48210	18.46087	1412.0	301.0	4.0	82.0	5.495722e+17	QSO	1.536277	488.0	51914.0	484.0

Most frequently occurring

	objid	ra	dec	u	g	r	i	z	run	rerun	camcol	field	specobjid	class	redshift	plate	mjd	fiberid	# duplicates
21	1.237650e+18	60.006771	-5.453765	18.53520	18.49669	18.12900	18.08370	18.07291	1045.0	301.0	4.0	173.0	5.225630e+17	QSO	1.381268	464.0	51908.0	529.0	3
94	1.237655e+18	148.865113	4.069995	19.21370	19.05957	18.95785	18.89791	18.96534	2125.0	301.0	4.0	201.0	6.430538e+17	QSO	1.436372	571.0	52286.0	600.0	3
103	1.237655e+18	200.831807	4.288257	19.39729	18.86379	18.69236	18.71441	18.55873	2190.0	301.0	2.0	126.0	5.360644e+18	QSO	2.325378	4761.0	55633.0	854.0	3
250	1.237659e+18	220.918335	55.258932	19.03294	18.97697	18.69969	18.61315	18.64826	3225.0	301.0	5.0	81.0	1.308459e+18	QSO	1.159161	1162.0	52668.0	594.0	3
253	1.237659e+18	259.377965	26.374453	18.91517	18.53948	18.44126	18.33421	18.10391	3225.0	301.0	5.0	349.0	5.632988e+18	QSO	2.202398	5003.0	55715.0	404.0	3
301	1.237661e+18	141.404255	33.260906	19.51994	19.38527	19.18023	19.32940	19.23339	3704.0	301.0	3.0	67.0	1.153174e+19	QSO	1.079241	10242.0	58161.0	980.0	3
393	1.237662e+18	215.824972	48.504365	19.04819	18.57168	18.48827	18.25663	18.12816	3918.0	301.0	4.0	139.0	9.495987e+18	QSO	0.568441	8434.0	57484.0	534.0	3
408	1.237662e+18	238.852274	34.659386	19.52406	19.25669	19.28052	19.08162	19.19201	3958.0	301.0	3.0	63.0	1.596615e+18	QSO	1.625367	1418.0	53142.0	324.0	3
412	1.237662e+18	245.379582	30.673344	19.50459	19.32491	19.33657	19.27321	19.52608	3958.0	301.0	4.0	109.0	1.229260e+19	QSO	1.402460	10918.0	58254.0	107.0	3
413	1.237662e+18	234.511749	38.360236	19.24319	19.02829	18.90838	18.90276	18.21580	3958.0	301.0	5.0	30.0	1.457072e+18	QSO	0.287838	1294.0	52753.0	574.0	3

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring